<?php

error_reporting(E_ALL);

/**
 * ConexionBD - class.funciones.php
 *
 * $Id$
 *
 * This file is part of ConexionBD.
 *
 * Automatically generated on 18.11.2009, 14:04:09 with ArgoUML PHP module 
 * (last revised $Date: 2008-04-19 08:22:08 +0200 (Sat, 19 Apr 2008) $)
 *
 * @author Miguel Angel Chavez
 */

if (0 > version_compare(PHP_VERSION, '5')) {
    die('This file was generated for PHP 5');
}

/**
 * include ConexionBD
 *
 * @author Miguel Angel Chavez
 */
require_once('class.ConexionBD.php');

/* user defined includes */
// section -64--88--126-60--16e069f3:12508088da3:-8000:0000000000000F86-includes begin
// section -64--88--126-60--16e069f3:12508088da3:-8000:0000000000000F86-includes end

/* user defined constants */
// section -64--88--126-60--16e069f3:12508088da3:-8000:0000000000000F86-constants begin
// section -64--88--126-60--16e069f3:12508088da3:-8000:0000000000000F86-constants end

/**
 * Short description of class funciones
 *
 * @access public
 * @author Miguel Angel Chavez
 */
class funciones
{
    // --- ASSOCIATIONS ---
    // generateAssociationEnd : 

    // --- ATTRIBUTES ---

    // --- OPERATIONS ---

    /**
     * Short description of method listaTransito
     *
     * @access public
     * @author Miguel Angel Chavez
     * @param  int sp
     * @param  int sector
     * @param  int status
     * @param  int estado
     * @return void
     */
    public function listaTransito($sp, $sector, $status, $estado)
    {
        // section -64--88--126-60--16e069f3:12508088da3:-8000:0000000000000F90 begin
               $stp=mssql_init($sp,$this->link);

        mssql_bind($stp,'@id_unidad',$sector,SQLVARCHAR,false,false,3);
        mssql_bind($stp,'@nStatus',$status,SQLVARCHAR,false,false,3);
        mssql_bind($stp,'@nEstado',$estado,SQLVARCHAR,false,false,3);

        $result='';
        $resutlSet=mssql_execute($stp);
        While($row=mssql_fetch_object($resutlSet)){
            $result.='<tr><td>'.$row->Unidad.'</td>
                          <td>'.$row->cNombre.' '.$row->cPaterno.' '.$row->cMaterno.'</td>
                          <td>'.$row->curp.'</td>
                          <td>'.$row->Muestra.'</td>
                          <td>'.$row->fMuestra.'</td>
                          <td>'.$row->cFolio.'</td></tr>';
        }
        return $result;
        // section -64--88--126-60--16e069f3:12508088da3:-8000:0000000000000F90 end
    }

} /* end of class funciones */

?>